|
|
Accounting Module of the Company Information System
Machala, Ondřej ; Husár, Adam (referee) ; Kříž, Jiří (advisor)
The subject of this project is the development of accounting module of the information system in company inLink CZ, s.r.o. The first part deals with the analysis of needs about accounting transactions, the relevant documents and subsequent financial analysis, selection of appropriate tools for the implementation and determination of the theoretical foundations. The practical part is focused on my own design solution, its implementation and deployment operations. The final part analyzes the usability and benefits of the project.
|
|
|
Renovation of a Ground School Information System
Bárta, Michal ; Rychlý, Marek (referee) ; Jaša, Petr (advisor)
The objective of this study is to modernize information system of Kamenice primary school and its components. Modernization concerns of the current application analysis and requirements for its use, then design a structure of new, modern and effective management system. Conditions of realization is to implement designed system in any PHP framework. Modernization also covers the data model and database structure, including the addition of transactions and integrity constraints in terms of export and preserving the original database data.
|
|
|
IS for CMR
Doležal, Tomáš ; Macho, Tomáš (referee) ; Holek, Radovan (advisor)
This dissertation is concerned with design and elaboration of MySQL database using PHP5 programming language. Goal of this work is customer support IS. To achieve it's goal uses Symfony PHP framework. E-R diagrams, dataflow diagrams as well as processes for each role are presented for this information system. Dissertation is also concerned with entities life cycles. Whole work results in the working information system, which contains administration and user frontend.
|
|
|
Administration of development documetation over WWW II
Gregárek, Ondřej ; Sysel, Petr (referee) ; Balík, Miroslav (advisor)
Document server is a web application controllable by way of web browser. It is meant to serve for the management of development documentation. The application is divided to the four basic parts: Requirements, Products, Tests and Test Run. The section Requirements serves for inserting requirements for products. Product is produced on the basis of these needs and registered in part Products. Test setting is created in the part Tests according to requirements from the part Requirements. Particular products are then tested. The part Test Run registers records of these tests. These are parts of the application: management of users, connecting supplements to records, printing and exportation of data to different formats, saving history of records, filtration and sorting of entries, etc. All the data is saved in the database MySQL. The application is written in scripting language PHP. Data is presented by template system Smarty. The output is in language XHTML. Cascading style CSS is used to formatting. This work describes development of the application. First it is dealing with the proposal of the database, connection and structure of particular tables. The function of the programme is explained in detail at the same time, which is essential for the correct proposal of the database. The application is based on the database. The selected structure of files and relations of scripts to library functions are shown. The template system and the interface for access of the programme to the database are explained. The most attention is paid to the description of solving important functions of the application, i.e. listing of records, their pagination, filtration, sorting and operation with them: saving, browsing, copying, confirmation and work with history, category and problems by upkeep of consistent tree and export of data to various formats. It is always outlined the problem, the idea of solving and the description of appropriate scripts. Samples of source code are also included for better understanding of complicated algorithms.
|
|
|
Optimization of Structured Queries on Large Databases
Janeček, Jiří ; Šebek, Michal (referee) ; Burget, Radek (advisor)
This master's thesis deals with optimization of structured queries on large databases. Principles of these optimizations are used during creation of application, which allows finding over one specific large database. At the same time this thesis compares efficiency between the new designed SQL constructions and the not optimized SQL constructions.
|
|
|
Optimization of Structured Queries on Large Databases
Janeček, Jiří ; Šebek, Michal (referee) ; Burget, Radek (advisor)
This master's thesis deals with optimization of structured queries on large databases. Principles of these optimizations are used during creation of application, which allows finding over one specific large database. At the same time this thesis compares efficiency between the new designed SQL constructions and the not optimized SQL constructions.
|
|
|
Accounting Module of the Company Information System
Machala, Ondřej ; Husár, Adam (referee) ; Kříž, Jiří (advisor)
The subject of this project is the development of accounting module of the information system in company inLink CZ, s.r.o. The first part deals with the analysis of needs about accounting transactions, the relevant documents and subsequent financial analysis, selection of appropriate tools for the implementation and determination of the theoretical foundations. The practical part is focused on my own design solution, its implementation and deployment operations. The final part analyzes the usability and benefits of the project.
|
|
|
Renovation of a Ground School Information System
Bárta, Michal ; Rychlý, Marek (referee) ; Jaša, Petr (advisor)
The objective of this study is to modernize information system of Kamenice primary school and its components. Modernization concerns of the current application analysis and requirements for its use, then design a structure of new, modern and effective management system. Conditions of realization is to implement designed system in any PHP framework. Modernization also covers the data model and database structure, including the addition of transactions and integrity constraints in terms of export and preserving the original database data.
|
|
|
IS for CMR
Doležal, Tomáš ; Macho, Tomáš (referee) ; Holek, Radovan (advisor)
This dissertation is concerned with design and elaboration of MySQL database using PHP5 programming language. Goal of this work is customer support IS. To achieve it's goal uses Symfony PHP framework. E-R diagrams, dataflow diagrams as well as processes for each role are presented for this information system. Dissertation is also concerned with entities life cycles. Whole work results in the working information system, which contains administration and user frontend.
|
|
|
Administration of development documetation over WWW II
Gregárek, Ondřej ; Sysel, Petr (referee) ; Balík, Miroslav (advisor)
Document server is a web application controllable by way of web browser. It is meant to serve for the management of development documentation. The application is divided to the four basic parts: Requirements, Products, Tests and Test Run. The section Requirements serves for inserting requirements for products. Product is produced on the basis of these needs and registered in part Products. Test setting is created in the part Tests according to requirements from the part Requirements. Particular products are then tested. The part Test Run registers records of these tests. These are parts of the application: management of users, connecting supplements to records, printing and exportation of data to different formats, saving history of records, filtration and sorting of entries, etc. All the data is saved in the database MySQL. The application is written in scripting language PHP. Data is presented by template system Smarty. The output is in language XHTML. Cascading style CSS is used to formatting. This work describes development of the application. First it is dealing with the proposal of the database, connection and structure of particular tables. The function of the programme is explained in detail at the same time, which is essential for the correct proposal of the database. The application is based on the database. The selected structure of files and relations of scripts to library functions are shown. The template system and the interface for access of the programme to the database are explained. The most attention is paid to the description of solving important functions of the application, i.e. listing of records, their pagination, filtration, sorting and operation with them: saving, browsing, copying, confirmation and work with history, category and problems by upkeep of consistent tree and export of data to various formats. It is always outlined the problem, the idea of solving and the description of appropriate scripts. Samples of source code are also included for better understanding of complicated algorithms.
|
guest ::
